package com.sunducation.wts.room.more2more.dao

import androidx.room.Dao
import androidx.room.Query
import androidx.room.Transaction
import com.sunducation.wts.room.more2more.bean.PlaylistWithSongs
import com.sunducation.wts.room.more2more.bean.SongWithPlaylists

@Dao
interface PlaylistSongCrossRefDao {
    @Transaction
    @Query("SELECT * FROM Playlist")
    fun getPlaylistsWithSongs(): List<PlaylistWithSongs>

    @Transaction
    @Query("SELECT * FROM Song")
    fun getSongsWithPlaylists(): List<SongWithPlaylists>
}